/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50713
 Source Host           : localhost
 Source Database       : eShopKeeper

 Target Server Type    : MySQL
 Target Server Version : 50713
 File Encoding         : utf-8

 Date: 12/07/2017 11:40:34 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `qrtz_cron_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(200) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_fired_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_job_details`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_locks`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_paused_trigger_grps`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_scheduler_state`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_simple_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_simprop_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `sys_catalog`
-- ----------------------------
DROP TABLE IF EXISTS `sys_catalog`;
CREATE TABLE `sys_catalog` (
  `id` bigint(32) NOT NULL COMMENT '流水号',
  `cascade_id` varchar(255) NOT NULL COMMENT '节点语义ID',
  `root_key` varchar(255) NOT NULL COMMENT '科目标识键',
  `root_name` varchar(255) NOT NULL COMMENT '科目名称',
  `name` varchar(255) NOT NULL COMMENT '分类名称',
  `hotkey` varchar(255) DEFAULT NULL COMMENT '热键',
  `parent_id` bigint(32) NOT NULL COMMENT '父节点流水号',
  `is_leaf` varchar(255) NOT NULL DEFAULT '1' COMMENT '是否叶子节点',
  `is_auto_expand` varchar(255) NOT NULL DEFAULT '0' COMMENT '是否自动展开',
  `icon_name` varchar(255) DEFAULT NULL COMMENT '图标文件名称',
  `sort_no` int(10) DEFAULT NULL COMMENT '排序号',
  `enable` tinyint(1) DEFAULT '1',
  `remark` varchar(5000) DEFAULT '1',
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sys_catalog_ukey` (`cascade_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分类表';

-- ----------------------------
--  Records of `sys_catalog`
-- ----------------------------
BEGIN;
INSERT INTO `sys_catalog` VALUES ('1', '0.001', 'PARAM_TYPE', '参数分类科目', '参数分类', null, '0', '0', '0', 'book.png', '0', '1', '1', '1', '2017-06-13 14:07:29', '1', '2017-06-13 14:07:29'), ('2', '0.002', 'DIC_TYPE', '词典分类科目', '数据字典分类', null, '0', '0', '0', 'book.png', '2', '1', '1', '1', '2017-06-13 14:07:29', '1', '2017-06-13 14:07:29'), ('3', '0.001.001', 'PARAM_TYPE', '参数分类科目', '业务参数', null, '1', '1', '0', 'user20.png', '2', '1', '1', '1', '2017-06-13 14:07:29', '1', '2017-06-13 14:07:29'), ('4', '0.001.002', 'PARAM_TYPE', '参数分类科目', '系统参数', null, '1', '0', '1', 'folder22.png', '1', '1', '1', '1', '2017-06-13 14:07:29', '1', '2017-06-13 14:07:29'), ('5', '0.002.001', 'DIC_TYPE', '词典分类科目', '系统管理', null, '2', '0', '1', 'folder22.png', '2', '1', '1', '1', '2017-06-13 14:07:29', '1', '2017-06-13 14:07:29'), ('6', '0.002.002', 'DIC_TYPE', '词典分类科目', '全局通用', null, '2', '1', '0', 'folder24.png', '3', '1', '1', '1', '2017-06-13 14:07:29', '1', '2017-06-13 14:07:29'), ('7', '0.002.006', 'DIC_TYPE', '词典分类科目', '平台配置', null, '2', '1', '0', 'folder2.png', '1', '1', '1', '1', '2017-06-13 14:07:29', '1', '2017-06-13 14:07:29'), ('8', '0.001.002.001', 'PARAM_TYPE', '参数分类科目', '验证码', null, '4', '1', '0', 'ok3.png', '2', '1', '1', '1', '2017-06-13 14:07:29', '1', '2017-06-13 14:07:29'), ('9', '0.001.002.002', 'PARAM_TYPE', '参数分类科目', '界面显示', null, '4', '1', '0', 'icon59.png', '1', '1', '1', '1', '2017-06-13 14:07:29', '1', '2017-06-13 14:07:29'), ('10', '0.001.002.003', 'PARAM_TYPE', '参数分类科目', '其它', null, '4', '1', '0', 'icon150.png', '9', '1', '1', '1', '2017-06-13 14:07:29', '1', '2017-06-13 14:07:29'), ('11', '0.001.002.004', 'PARAM_TYPE', '参数分类科目', '导航与菜单', null, '4', '1', '0', 'icon152.png', '3', '1', '1', '1', '2017-06-13 14:07:29', '1', '2017-06-13 14:07:29'), ('12', '0.002.001.001', 'DIC_TYPE', '词典分类科目', '工作流', null, '5', '1', '0', 'folder6.png', '1', '1', '1', '1', '2017-06-13 14:07:29', '1', '2017-06-13 14:07:29');
COMMIT;

-- ----------------------------
--  Table structure for `sys_dept`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` bigint(32) NOT NULL COMMENT '部门编号',
  `dept_name` varchar(50) DEFAULT NULL COMMENT '部门名称',
  `parent_id` bigint(32) DEFAULT NULL COMMENT '上级部门编号',
  `sort_no` int(3) DEFAULT NULL COMMENT '排序号',
  `leaf` int(1) DEFAULT NULL COMMENT '叶子节点(0:树枝节点;1:叶子节点)',
  `enable` tinyint(1) DEFAULT NULL COMMENT '启用状态',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='部门';

-- ----------------------------
--  Records of `sys_dept`
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES ('1', 'eShopKeeper', '0', '1', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:06');
COMMIT;

-- ----------------------------
--  Table structure for `sys_dic`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dic`;
CREATE TABLE `sys_dic` (
  `id` bigint(32) NOT NULL,
  `index_id` bigint(32) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  `code_text` varchar(100) DEFAULT NULL,
  `sort_no` int(2) DEFAULT NULL,
  `editable` tinyint(1) NOT NULL DEFAULT '1',
  `enable` tinyint(1) NOT NULL DEFAULT '1',
  `remark` varchar(500) DEFAULT NULL,
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `field_id_code` (`index_id`,`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典明细表';

-- ----------------------------
--  Records of `sys_dic`
-- ----------------------------
BEGIN;
INSERT INTO `sys_dic` VALUES ('1', '1', '0', '未知', '1', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:13'), ('2', '1', '1', '男', '2', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:12'), ('3', '1', '2', '女', '3', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:11'), ('4', '2', '0', '激活', '1', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:11'), ('5', '2', '1', '锁定', '2', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:10'), ('6', '3', '1', '业务角色', '1', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:09'), ('7', '3', '2', '管理角色', '2', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:09'), ('8', '3', '3', '系统内置角色', '3', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:08'), ('9', '4', '0', '树枝节点', '1', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:07'), ('10', '4', '1', '叶子节点', '2', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:07'), ('11', '5', '0', '只读', '1', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:06'), ('12', '5', '1', '可编辑', '2', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:06'), ('13', '6', '0', '禁用', '1', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:05'), ('14', '6', '1', '启用', '2', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:04'), ('15', '7', '1', '访问权限', '1', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:03'), ('16', '7', '2', '管理权限', '2', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:02'), ('17', '8', '1', '系统菜单', '1', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:03'), ('18', '8', '2', '业务菜单', '2', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:01'), ('19', '9', '1', '经办员', '1', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:03:50'), ('20', '9', '2', '管理员', '2', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:03:48'), ('21', '9', '3', '系统内置用户', '3', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:03:47'), ('22', '10', '0', '收缩', '1', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:03:47'), ('23', '10', '1', '展开', '2', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:03:46'), ('24', '11', 'add', '新增', '1', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:03:56'), ('25', '11', 'read', '查询', '2', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:03:58'), ('26', '11', 'update', '修改', '3', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:03:59'), ('27', '11', 'delete', '删除', '4', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:03:59'), ('28', '11', 'open', '打开', '5', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:00'), ('29', '11', 'close', '关闭', '6', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:01'), ('30', '11', 'run', '执行', '7', '0', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-06-28 18:04:01');
COMMIT;

-- ----------------------------
--  Table structure for `sys_dic_index`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dic_index`;
CREATE TABLE `sys_dic_index` (
  `id` bigint(32) NOT NULL,
  `catalog_id` bigint(32) NOT NULL DEFAULT '0',
  `key` varchar(50) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `enable` tinyint(1) DEFAULT '1',
  `remark` varchar(1000) DEFAULT NULL,
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典索引表';

-- ----------------------------
--  Records of `sys_dic_index`
-- ----------------------------
BEGIN;
INSERT INTO `sys_dic_index` VALUES ('1', '6', 'SEX', '性别', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-07-30 00:06:53'), ('2', '6', 'LOCKED', '锁定', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-07-30 00:06:49'), ('3', '5', 'ROLETYPE', '角色类型', '1', null, '1', '2017-07-30 00:06:30', '1', '2017-07-30 00:06:50'), ('4', '6', 'LEAF', '节点类型', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-07-30 00:06:48'), ('5', '5', 'EDITABLE', '编辑模式', '1', null, '1', '2017-07-30 00:06:33', '1', '2017-07-30 00:06:47'), ('6', '5', 'ENABLE', '启用状态', '1', null, '1', '2017-07-30 00:06:35', '1', '2017-07-30 00:06:45'), ('7', '5', 'AUTHORIZELEVEL', '权限级别', '1', null, '1', '2017-07-30 00:06:37', '1', '2017-07-30 00:06:44'), ('8', '5', 'MENUTYPE', '菜单类型', '1', null, '1', '2017-07-30 00:06:38', '1', '2017-07-30 00:06:40'), ('9', '5', 'USERTYPE', '人员类型', '1', null, '1', '2017-07-30 00:06:43', '1', '2017-07-30 00:06:41'), ('10', '6', 'EXPAND', '展开状态', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-07-30 00:06:52'), ('11', '5', 'CRUD', '操作类型', '1', null, '1', '2017-06-28 18:04:06', '1', '2017-07-30 00:06:51');
COMMIT;

-- ----------------------------
--  Table structure for `sys_event`
-- ----------------------------
DROP TABLE IF EXISTS `sys_event`;
CREATE TABLE `sys_event` (
  `id` bigint(32) NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `request_uri` varchar(50) DEFAULT NULL,
  `parameters` varchar(500) DEFAULT NULL,
  `method` varchar(20) DEFAULT NULL,
  `client_host` varchar(50) DEFAULT NULL,
  `user_agent` varchar(300) DEFAULT NULL,
  `status` int(3) DEFAULT NULL,
  `enable` tinyint(1) DEFAULT NULL,
  `remark` text,
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_event`
-- ----------------------------
BEGIN;
INSERT INTO `sys_event` VALUES ('938064634804367360', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '服务器出错', '1', '2017-12-05 23:16:52', '1', '2017-12-05 23:16:52'), ('938064705683910656', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '服务器出错', '1', '2017-12-05 23:17:09', '1', '2017-12-05 23:17:09'), ('938064901071368192', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '服务器出错', '1', '2017-12-05 23:17:55', '1', '2017-12-05 23:17:55'), ('938065348964315136', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '服务器出错', '1', '2017-12-05 23:19:42', '1', '2017-12-05 23:19:42'), ('938065661813256192', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '用户名或密码错误.', '1', '2017-12-05 23:20:57', '1', '2017-12-05 23:20:57'), ('938065823314931712', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '用户名或密码错误.', '1', '2017-12-05 23:21:35', '1', '2017-12-05 23:21:35'), ('938066194607300608', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '', '1', '2017-12-05 23:23:04', '1', '2017-12-05 23:23:04'), ('938069046897557504', null, '/logout', '{}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '', '1', '2017-12-05 23:34:24', '1', '2017-12-05 23:34:24'), ('938069119698092032', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '服务器出错', '1', '2017-12-05 23:34:41', '1', '2017-12-05 23:34:41'), ('938069441241825280', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '服务器出错', '1', '2017-12-05 23:35:58', '1', '2017-12-05 23:35:58'), ('938069752211718144', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '服务器出错', '1', '2017-12-05 23:37:12', '1', '2017-12-05 23:37:12'), ('938069876186955776', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '服务器出错', '1', '2017-12-05 23:37:42', '1', '2017-12-05 23:37:42'), ('938070081846263808', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '', '1', '2017-12-05 23:38:31', '1', '2017-12-05 23:38:31'), ('938070880471105536', null, '/logout', '{}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '', '1', '2017-12-05 23:41:41', '1', '2017-12-05 23:41:41'), ('938070933344501760', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '', '1', '2017-12-05 23:41:54', '1', '2017-12-05 23:41:54'), ('938071061920890880', null, '/logout', '{}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '', '1', '2017-12-05 23:42:24', '1', '2017-12-05 23:42:24'), ('938071104778289152', null, '/login', '{\"account\":[\"admin\"],\"password\":[\"111111\"]}', 'POST', '192.168.1.10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', '200', '1', '', '1', '2017-12-05 23:42:35', '1', '2017-12-05 23:42:35');
COMMIT;

-- ----------------------------
--  Table structure for `sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint(32) NOT NULL COMMENT '菜单编号',
  `menu_name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `menu_type` tinyint(1) DEFAULT '2' COMMENT '菜单类型(0:CURD;1:系统菜单;2:业务菜单;)',
  `parent_id` bigint(32) DEFAULT NULL COMMENT '上级菜单编号',
  `iconcls` varchar(50) DEFAULT NULL COMMENT '节点图标CSS类名',
  `request` varchar(100) DEFAULT NULL COMMENT '请求地址',
  `expand` tinyint(1) NOT NULL DEFAULT '0' COMMENT '展开状态(1:展开;0:收缩)',
  `sort_no` int(2) DEFAULT NULL COMMENT '排序号',
  `is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '叶子节点(0:树枝节点;1:叶子节点)',
  `permission` varchar(50) DEFAULT NULL COMMENT '权限标识',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `enable` tinyint(1) DEFAULT '1',
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='菜单';

-- ----------------------------
--  Records of `sys_menu`
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES ('1', '系统管理', '1', '0', 'glyphicon glyphicon-cog', '#', '0', '1', '1', 'sys', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-29 08:19:19'), ('2', '用户管理', '1', '1', 'glyphicon glyphicon-user', 'main.sys.user.list', '0', '1', '1', 'sys.user', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-29 08:38:35'), ('3', '部门管理', '1', '1', 'glyphicon glyphicon-flag', 'main.sys.dept.list', '0', '2', '1', 'sys.dept', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-28 18:07:43'), ('4', '菜单管理', '1', '1', 'glyphicon glyphicon-list', 'main.sys.menu.list', '0', '3', '1', 'sys.menu', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-28 18:07:45'), ('5', '角色管理', '1', '1', 'glyphicon glyphicon-tags', 'main.sys.role.list', '0', '4', '1', 'sys.role', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-28 18:07:47'), ('6', '会话管理', '1', '1', 'glyphicon glyphicon-earphone', 'main.sys.session.list', '0', '6', '1', 'sys.session', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-28 18:07:49'), ('7', '字典管理', '1', '1', 'glyphicon glyphicon-book', 'main.sys.dic.list', '0', '7', '1', 'sys.dic', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-28 18:07:50'), ('8', '参数管理', '1', '1', 'glyphicon glyphicon-wrench', 'main.sys.param.list', '0', '8', '1', 'sys.param', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-28 18:07:52'), ('9', '调度中心', '1', '0', 'glyphicon glyphicon-fire', '#', '0', '2', '1', 'task', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-30 14:23:57'), ('10', '任务组管理', '1', '9', 'glyphicon glyphicon-equalizer', 'main.task.group.list', '0', '1', '1', 'task.group', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-28 18:08:21'), ('11', '任务管理', '1', '9', 'glyphicon glyphicon-bookmark', 'main.task.scheduler.list', '0', '2', '1', 'task.scheduler', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-28 18:08:25'), ('12', '调度管理', '1', '9', 'glyphicon glyphicon-random', 'main.task.scheduled.list', '0', '3', '1', 'task.scheduled', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-30 14:24:02'), ('13', '调度日志', '1', '9', 'glyphicon glyphicon-file', 'main.task.log.list', '0', '4', '1', 'task.log', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-28 18:08:48'), ('14', '清除缓存', '1', '1', null, null, '0', '9', '0', 'sys.cache', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-29 09:39:25'), ('15', '用户权限', '1', '1', null, null, '0', '10', '0', 'user.menu', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-29 09:39:27'), ('16', '用户角色', '1', '1', null, null, '0', '11', '0', 'user.role', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-29 09:39:29'), ('17', '角色权限', '1', '1', null, null, '0', '12', '0', 'role.menu', null, '1', '1', '2017-06-20 09:16:56', '1', '2017-06-29 09:39:33');
COMMIT;

-- ----------------------------
--  Table structure for `sys_param`
-- ----------------------------
DROP TABLE IF EXISTS `sys_param`;
CREATE TABLE `sys_param` (
  `id` bigint(32) NOT NULL COMMENT '参数编号',
  `param_key` varchar(50) DEFAULT NULL COMMENT '参数键名',
  `param_value` varchar(100) DEFAULT NULL COMMENT '参数键值',
  `catalog_id` bigint(32) DEFAULT NULL,
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `enable` tinyint(1) DEFAULT '1',
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全局参数表';

-- ----------------------------
--  Table structure for `sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(32) NOT NULL COMMENT '角色编号',
  `role_name` varchar(50) DEFAULT NULL COMMENT '角色名称',
  `dept_id` bigint(32) DEFAULT NULL COMMENT '所属部门编号',
  `role_type` int(1) NOT NULL DEFAULT '1' COMMENT '角色类型(1:业务角色;2:管理角色 ;3:系统内置角色)',
  `enable` tinyint(1) NOT NULL DEFAULT '1',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色信息表';

-- ----------------------------
--  Records of `sys_role`
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1', '管理员', '1', '1', '1', null, '1', '2017-06-20 09:16:56', '1', '2017-06-20 09:16:56');
COMMIT;

-- ----------------------------
--  Table structure for `sys_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint(32) NOT NULL,
  `menu_id` bigint(32) NOT NULL,
  `permission` varchar(50) NOT NULL COMMENT '权限标识',
  `enable` tinyint(1) DEFAULT '1',
  `remark` varchar(5000) DEFAULT NULL,
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`role_id`,`menu_id`,`permission`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色授权表';

-- ----------------------------
--  Records of `sys_role_menu`
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES ('1', '1', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:04'), ('1', '2', 'add', '1', null, '1', '2017-06-29 09:10:10', '1', '2017-06-29 09:10:10'), ('1', '2', 'delete', '1', null, '1', '2017-06-29 09:10:29', '1', '2017-06-29 09:10:29'), ('1', '2', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:07'), ('1', '2', 'update', '1', null, '1', '2017-06-29 09:10:20', '1', '2017-06-29 09:10:20'), ('1', '3', 'add', '1', null, '1', '2017-06-29 09:10:50', '1', '2017-06-29 09:10:50'), ('1', '3', 'delete', '1', null, '1', '2017-06-29 09:11:18', '1', '2017-06-29 09:11:18'), ('1', '3', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:08'), ('1', '3', 'update', '1', null, '1', '2017-06-29 09:11:01', '1', '2017-06-29 09:11:01'), ('1', '4', 'add', '1', null, '1', '2017-06-29 09:12:14', '1', '2017-06-29 09:12:14'), ('1', '4', 'delete', '1', null, '1', '2017-06-29 09:18:43', '1', '2017-06-29 09:18:43'), ('1', '4', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:08'), ('1', '4', 'update', '1', null, '1', '2017-06-29 09:18:33', '1', '2017-06-29 09:18:33'), ('1', '5', 'add', '1', null, '1', '2017-06-29 09:19:00', '1', '2017-06-29 09:19:00'), ('1', '5', 'delete', '1', null, '1', '2017-06-29 09:19:24', '1', '2017-06-29 09:19:24'), ('1', '5', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:09'), ('1', '5', 'update', '1', null, '1', '2017-06-29 09:19:10', '1', '2017-06-29 09:19:10'), ('1', '6', 'delete', '1', null, '1', '2017-06-29 09:19:35', '1', '2017-06-29 09:19:35'), ('1', '6', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:09'), ('1', '7', 'add', '1', null, '1', '2017-06-29 09:19:58', '1', '2017-06-29 09:19:58'), ('1', '7', 'delete', '1', null, '1', '2017-06-29 09:20:18', '1', '2017-06-29 09:20:18'), ('1', '7', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:10'), ('1', '7', 'update', '1', null, '1', '2017-06-29 09:20:08', '1', '2017-06-29 09:20:08'), ('1', '8', 'add', '1', null, '1', '2017-06-29 09:20:34', '1', '2017-06-29 09:20:34'), ('1', '8', 'delete', '1', null, '1', '2017-06-29 09:20:53', '1', '2017-06-29 09:20:53'), ('1', '8', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:11'), ('1', '8', 'update', '1', null, '1', '2017-06-29 09:20:44', '1', '2017-06-29 09:20:44'), ('1', '9', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:11'), ('1', '10', 'add', '1', null, '1', '2017-06-29 09:21:24', '1', '2017-06-29 09:21:24'), ('1', '10', 'delete', '1', null, '1', '2017-06-29 09:21:44', '1', '2017-06-29 09:21:44'), ('1', '10', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:12'), ('1', '10', 'update', '1', null, '1', '2017-06-29 09:21:35', '1', '2017-06-29 09:21:35'), ('1', '11', 'add', '1', null, '1', '2017-06-29 09:21:55', '1', '2017-06-29 09:21:55'), ('1', '11', 'delete', '1', null, '1', '2017-06-29 09:22:07', '1', '2017-06-29 09:22:32'), ('1', '11', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:13'), ('1', '11', 'update', '1', null, '1', '2017-06-29 09:22:49', '1', '2017-06-29 09:22:49'), ('1', '12', 'close', '1', null, '1', '2017-06-29 08:45:21', '1', '2017-06-29 08:45:21'), ('1', '12', 'open', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:13'), ('1', '12', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:13'), ('1', '12', 'run', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:13'), ('1', '13', 'read', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:23:14'), ('1', '14', 'update', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:43:18'), ('1', '15', 'update', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:43:33'), ('1', '16', 'update', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:43:34'), ('1', '17', 'update', '1', null, '1', '2017-06-28 18:18:50', '1', '2017-06-29 08:43:35');
COMMIT;

-- ----------------------------
--  Table structure for `sys_session`
-- ----------------------------
DROP TABLE IF EXISTS `sys_session`;
CREATE TABLE `sys_session` (
  `id` bigint(32) NOT NULL,
  `session_id` varchar(50) DEFAULT NULL,
  `account` varchar(50) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `start_time` datetime NOT NULL,
  `enable` tinyint(1) DEFAULT NULL,
  `remark` varchar(5000) DEFAULT NULL,
  `create_time` datetime NOT NULL,
  `create_by` bigint(32) DEFAULT NULL,
  `update_time` datetime NOT NULL,
  `update_by` bigint(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会话管理';

-- ----------------------------
--  Records of `sys_session`
-- ----------------------------
BEGIN;
INSERT INTO `sys_session` VALUES ('938071104648265728', '215f63e4-bca6-4c36-b79a-f01ede965c21', 'admin', '192.168.1.10', '2017-12-05 23:42:31', null, null, '2017-12-05 23:42:35', null, '2017-12-05 23:42:35', null);
COMMIT;

-- ----------------------------
--  Table structure for `sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(32) NOT NULL,
  `account` varchar(20) DEFAULT NULL COMMENT '登陆帐户',
  `password` varchar(50) DEFAULT NULL COMMENT '密码',
  `phone` varchar(50) DEFAULT NULL COMMENT '电话',
  `sex` int(1) NOT NULL DEFAULT '0' COMMENT '性别(0:未知;1:男;2:女)',
  `user_name` varchar(30) DEFAULT NULL COMMENT '用户名',
  `avatar` varchar(500) DEFAULT NULL,
  `user_type` int(1) DEFAULT '1' COMMENT '人员类型(1:经办员;2:管理员;3:系统内置人员;)',
  `dept_id` bigint(32) DEFAULT '1' COMMENT '部门编号',
  `locked` tinyint(1) DEFAULT '0' COMMENT '锁定标志(1:锁定;0:激活)',
  `enable` tinyint(1) DEFAULT '1',
  `remark` varchar(5000) DEFAULT '1',
  `create_time` datetime NOT NULL,
  `create_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account` (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_user`
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('1', 'admin', 'i/sV2VpTPy7Y+ppesmkCmM==', '15333821711', '0', 'admin', 'res/img/favicon.jpg', '3', '1', '0', '1', '1', '2017-05-06 10:06:52', '1', '2017-06-13 14:04:38', '1', null), ('2', 'test', 'i/sV2VpTPy7Y+ppesmkCmM==', '12345678901', '0', 'test', null, '1', '1', '0', '1', '1', '2017-05-13 16:58:17', '1', '2017-06-13 14:04:38', '1', null);
COMMIT;

-- ----------------------------
--  Table structure for `sys_user_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_menu`;
CREATE TABLE `sys_user_menu` (
  `user_id` bigint(32) NOT NULL,
  `menu_id` bigint(32) NOT NULL,
  `permission` varchar(50) NOT NULL COMMENT '权限标识',
  `enable` tinyint(1) DEFAULT NULL,
  `remark` varchar(5000) DEFAULT NULL,
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`user_id`,`menu_id`,`permission`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户授权表';

-- ----------------------------
--  Table structure for `sys_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` bigint(32) NOT NULL,
  `role_id` bigint(32) NOT NULL,
  `enable_` tinyint(1) DEFAULT NULL,
  `remark_` varchar(5000) DEFAULT NULL,
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户授权表';

-- ----------------------------
--  Records of `sys_user_role`
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES ('1', '1', null, null, '1', '2017-06-16 15:59:56', '1', '2017-06-16 15:59:56');
COMMIT;

-- ----------------------------
--  Table structure for `sys_user_thirdparty`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_thirdparty`;
CREATE TABLE `sys_user_thirdparty` (
  `id` bigint(32) NOT NULL,
  `user_id` bigint(32) NOT NULL,
  `provider` varchar(50) NOT NULL COMMENT '第三方类型',
  `open_id` varchar(50) NOT NULL COMMENT '第三方Id',
  `enable` tinyint(1) DEFAULT NULL,
  `remark` varchar(5000) DEFAULT NULL,
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id_provider__open_id` (`user_id`,`provider`,`open_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='第三方用户';

-- ----------------------------
--  Table structure for `task_fire_log`
-- ----------------------------
DROP TABLE IF EXISTS `task_fire_log`;
CREATE TABLE `task_fire_log` (
  `id_` bigint(32) NOT NULL,
  `group_name` varchar(50) NOT NULL,
  `task_name` varchar(50) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `status_` varchar(1) NOT NULL DEFAULT 'I',
  `server_host` varchar(50) DEFAULT NULL COMMENT '服务器名',
  `server_duid` varchar(50) DEFAULT NULL COMMENT '服务器网卡序列号',
  `fire_info` text,
  PRIMARY KEY (`id_`),
  UNIQUE KEY `group_name_task_name_start_time` (`group_name`,`task_name`,`start_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `task_group`
-- ----------------------------
DROP TABLE IF EXISTS `task_group`;
CREATE TABLE `task_group` (
  `id_` bigint(32) NOT NULL,
  `group_name` varchar(50) NOT NULL,
  `group_desc` varchar(50) NOT NULL,
  `remark_` varchar(5000) NOT NULL,
  `enable_` tinyint(1) DEFAULT '1',
  `create_time` datetime NOT NULL,
  `create_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  PRIMARY KEY (`id_`),
  UNIQUE KEY `group_name` (`group_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `task_group`
-- ----------------------------
BEGIN;
INSERT INTO `task_group` VALUES ('1', 'coreTaskProvider', '系统管理', '', '1', '2017-05-27 14:56:51', '1', '2017-06-16 10:18:58', '1');
COMMIT;

-- ----------------------------
--  Table structure for `task_scheduler`
-- ----------------------------
DROP TABLE IF EXISTS `task_scheduler`;
CREATE TABLE `task_scheduler` (
  `id_` bigint(32) NOT NULL,
  `group_id` bigint(32) NOT NULL,
  `task_name` varchar(50) NOT NULL,
  `task_type` varchar(50) NOT NULL,
  `task_desc` varchar(50) DEFAULT NULL,
  `task_cron` varchar(50) NOT NULL,
  `contact_email` varchar(500) DEFAULT NULL COMMENT '多个邮箱用,分割',
  `remark_` varchar(5000) DEFAULT NULL,
  `enable_` tinyint(1) DEFAULT '1',
  `create_by` bigint(32) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_by` bigint(32) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id_`),
  UNIQUE KEY `group_id_task_name` (`group_id`,`task_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `task_scheduler`
-- ----------------------------
BEGIN;
INSERT INTO `task_scheduler` VALUES ('1', '1', 'cleanExpiredSessions', 'local', '清理无效session', '0 * * * * ?', 'eShopKeeper@126.com', null, '1', '1', '2017-06-13 14:05:30', '1', '2017-09-21 11:30:00');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
